SELECT id_Resource, id_Globalization, ParamName, ParamStringValue, ParamObjectValue, ParamType
FROM   tbl_ResourceSQL
WHERE  (id_Globalization = 'en-us') AND (ParamName = 'Param_1') AND (ParamStringValue = N'Val_Param_1_ENG')


alter PROCEDURE dbo.Mng_GetResource
	(@id_Globalization varchar(50), @ParamName varchar(500)=null, @ParamStringValue nvarchar(max)=null)
as
SELECT id_Resource, id_Globalization, ParamName, ParamStringValue, ParamObjectValue, ParamType
FROM   tbl_ResourceSQL
WHERE
	(id_Globalization = @id_Globalization) 
	AND (ParamName = 
			case 
			when @ParamName IS null OR @ParamName = '' then ParamName
			else @ParamName
			END
		) 
	AND (ParamStringValue = 
			case 
			when @ParamStringValue IS null OR @ParamStringValue = '' then ParamStringValue
			else @ParamStringValue
			END
		)

 